<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>无标题文档</title>
</head>

<body>
<?php  include 'action/session_check.php'; //登录判断  ?>  
<form action="" method="post">
<table>
<tr>
<td colspan="16">招聘信息管理 </td></tr>
<tr>
    <td>编号</td><td>职位类别</td><td>职位名称</td><td>状态</td><td>发布时间</td>
    <td>发布</td><td>放入回收站</td><td colspan="2">操作</td>
   </tr>
 <?php
  include("../conn/conn_db.php");    //包含数据库连接文件 
  $sql = "select r.*,rt.rt_name from recruit_info r,recruit_type rt where r.rt_id = rt.rt_id order by r_createtime desc"; //查询语句
  $result = $conn->query($sql);                //执行SQL语句
  while($row = $result->fetch_array())   //遍历查询结果的每一行
  {
?>
  <tr>
    <td> <?php echo $row["r_id"];?>   </td>
    <td> <?php echo $row["rt_name"];?></td>   
    <td> <?php echo $row["r_name"];?></td>
    <td> <?php echo $row["r_status"]=='1'? '<font color=blue>已发布</font>':'<font color=red>未发布</font>';?>  </td>
    <td> <?php echo $row["r_createtime"];?></td>
    <td><a href="action/recruit_action_do.php?Type=1&r_id=<?php echo $row["r_id"];?>">发布</a></td>
    <td><a href="action/recruit_action_do.php?Type=2&r_id=<?php echo $row["r_id"];?>">放入回收站</a></td>
    <td><a href="recruit_update.php?r_id=<?php echo $row["r_id"];?>">修改</a></td>
    <td><a href="action/recruit_action_do.php?Type=3&r_id=<?php echo $row["r_id"];?>">删除</a></td>
  </tr>
<?php }  ?>
 </table>
 </form>
</body>
</html>